package com.seaside.park.mapper;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.seaside.park.bean.Navi;

@Mapper
public interface NaviMapper extends BaseMapper<Navi> {
	
    @Select("SELECT n.* FROM navi n, park_place p, park_zone pz WHERE 1=1 AND n.park_id = pz.zone_id AND pz.zone_id = p.zone_id AND pz.zone_no = #{parkZoneNo} AND p.park_no = #{parkPlaceNo}")
    Navi getNaviInfo(String parkZoneNo, String parkPlaceNo);
	
}
